Skip to main content

Reconciliation Discrepancy Guide

Match your Connected Payments transaction reports with bank settlements to identify and resolve discrepancies.

What is Reconciliation?​

Reconciliation is matching your Connected Payments reports with bank settlement statements to ensure all transactions are accounted for correctly.

Calculate variance:

Variance = Bank Settlement - Connected Payments Report Total

Before Contacting Support​

Verify these first:

  • Connected Payments report matches date range of bank settlement
  • All hierarchies included in report
  • Correct settlement date (T+1 or T+2)
  • Checked for error codes: 91, 99, 799, 790

How to Reconcile​

Step 1: Identify Variance​

  1. Generate Connected Payments reconciliation report
  2. Download bank settlement statement
  3. Compare totals
  4. Calculate variance

Example:

Bank Settlement:    $10,500.00
Connected Payments Report Total:  $10,000.00
Variance:           $500.00

Step 2: Investigate​

If Bank > Connected Payments:

  • Look for declined transactions with error codes 91, 99, 799, 790
  • These may have actually processed

If Bank < Connected Payments:

  • Verify approved transactions actually settled
  • Check for reversals or chargebacks

Step 3: Gather Information​

Collect:

  • Variance amount
  • Settlement period and date
  • Report filters used (screenshot)
  • Transaction IDs with error codes
  • Bank settlement statement

Step 4: Contact Connected Payments Support​

Email: [email protected]

Subject: Reconciliation Variance - [Your Company] - [Date]

Best Practices​

Report Generation​

Best PracticeWhy
Use consistent date rangesMatch bank settlement periods
Include all channelsAPI, iFrame, Virtual Terminal
Check all hierarchiesDon't miss business units
Account for T+1/T+2Transactions settle 1-2 days later
Export reportsKeep copies for records

Error Monitoring​

warning

Watch for error codes 91, 99, 799, and 790 - these indicate high risk of reconciliation discrepancies.

When you see these codes:

  1. Note the transaction details
  2. Check if transaction appears in bank settlement
  3. Report to Connected Payments support if discrepancy found

Troubleshooting​

Check:

  • Correct date range (account for T+1/T+2)
  • All hierarchies included
  • All channels included
  • Weekends and holidays

If still unresolved:

  • Contact Connected Payments support with complete details
  • Provide bank settlement report